package com.hrbxlh.dao;

import java.util.List;
import java.util.Map;

import org.springframework.stereotype.Repository;

@Repository
public interface DepartMentDao {
	
	/**
	 * @description 获取全部院系信息
	 * @param Map<String, Object> 参数与数据库column一致。
	 * @return List<Map<String,String>> 部门集合
	 * @throws Exception
	 */
	public List<Map<String,Object>> getDepartMentList(Map<String, Object> paramMap) throws Exception;

	/**
	 * @description 查询院系列表信息  （分页）
	 * @param Map<String,Object> paramMap
	 * @return List 
	 * @throws Exception
	 */
	public List<Map<String,Object>> getDepartmentList(Map<String, Object> paramMap) throws Exception;

	/**
	 * @description 通过院系名字查询是不是有这个院系
	 * @param Map<String,Object> paramMap
	 * @return List 
	 * @throws Exception
	 */
	public List<Map<String,Object>> getDepartmentByName(Map<String, Object> paramMap) throws Exception;
	
	/**
	 * @description 添加院系
	 * @param Map<String,Object> paramMap
	 * @return List 
	 * @throws Exception
	 */
	public void addDepartment(Map<String, Object> paramMap) throws Exception;
	
	/**
	 * @description 修改院系
	 * @param Map<String,Object> paramMap
	 * @return List 
	 * @throws Exception
	 */
	public void saveDepartment(Map<String, Object> paramMap) throws Exception;
	
	/**
	 * @description 删除院系
	 * @param Map<String,Object> paramMap
	 * @return List 
	 * @throws Exception
	 */
	public void delDepartment(Map<String, Object> paramMap) throws Exception;
	
	/**
	 * @description 查询某院系的专业管理列表  分页
	 * @param Map<String,Object> paramMap
	 * @return List 
	 * @throws Exception
	 */
	public List<Map<String,Object>> getDepartmentProfesList(Map<String, Object> paramMap) throws Exception;
	
	/**
	 * @description 删除这个院系下所有专业信息
	 * @param Map<String,Object> paramMap
	 * @return List 
	 * @throws Exception
	 */
	public void delProfessionByDepId(Map<String, Object> paramMap) throws Exception;
	
	/**
	 * @description 查询某个表是否有某个字段的信息
	 * @param Map<String,Object> paramMap
	 * @return List 
	 * @throws Exception
	 */
	public List<Map<String,Object>> getMsgList(Map<String, Object> paramMap) throws Exception;
	    
	 /**
	 * @description 通过主键查询某院系信息
	 * @param Map<String,Object> paramMap
	 * @return List 
	 * @throws Exception
	 */
	public Map<String,Object> getDepartmentDetail(Map<String, Object> paramMap) throws Exception;

	 /**
	 * @description 通过某院系id查询下面全部专业信息
	 * @param Map<String,Object> paramMap
	 * @return List 
	 * @throws Exception
	 */
	public List<Map<String,Object>> getMyProfessionList(Map<String, Object> paramMap) throws Exception;
}
